2013-03-21 - 5910.200 - Rel Notes - Contracts - Release 003 #BIReleases2013
Release Notes:
5910.200 - Contracts - OSA900
Admin Info
Purpose
|
Including Contract Information in OSA900 report
|
Release No
|
003
|
Submitted
|
03-21-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
OSA 900 - Open Orders by Sales Org, SBU, Sales Rep, Customer, Season and Collection
BEx Query
ZMP_OPASA_Q030
NEC Crystal Reports Standards Check
1. OSA900 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA900 NEC CR checklist has been sent to NEC and also attached here for reference.
OSA900 NEC CR Standard Check List.xlsx
Dynamic Group 1:
Test Conducted
Dynamic Grouping Parameter(1) and Group Name: SBU > Sales Rep > Customer > Season > Collection
Summary Level Check
Test Conducted
Group: Sales Orgs > 5th & Ocean Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,440,683
|
1,440,683
|
Pass
|
2
|
Sales Org Currency
|
13,492,910
|
13,492,910.07
|
Pass
|
3
|
Corporate Currency
|
13,492,910
|
13,492,910.07
|
Pass
|
Group: Sales Orgs > EMEA Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,792,560
|
1,792,560
|
Pass
|
2
|
Sales Org Currency
|
15,654,086
|
15,654,084.20
|
Fail
|
3
|
Corporate Currency
|
23,839,615
|
23,839,597.43
|
Fail
|
Note: For EMEA Sales, Sales Org, Sales Org Currency and Corporate Currency values are not matching with BEx Query values. The difference is $2 & $18 respectively because of rounding issue.
Second Level Check
Test Conducted
Group: APAC Sales > Accessories
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,209
|
1,209
|
Pass
|
2
|
Sales Org Currency
|
136,577
|
136,576.63
|
Pass
|
3
|
Corporate Currency
|
17,611
|
17,610.52
|
Pass
|
Third Level Check
Test Conducted
Group: Australia Sales > Mens Apparel > Arthur Kerr
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
12
|
12
|
Pass
|
2
|
Sales Org Currency
|
386
|
386.40
|
Pass
|
3
|
Corporate Currency
|
396
|
395.94
|
Pass
|
Group : EMEA Sales > Headwear > Charles Colleville
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
20,179
|
20,179
|
Pass
|
2
|
Sales Org Currency
|
221,249
|
221,248.63
|
Pass
|
3
|
Corporate Currency
|
336,929
|
336,927.37
|
Fail
|
Note: For EMEA Sales, Sales Org, Corporate Currency value is not matching with BEx Query values because of rounding issue.
Fourth Level Check
Test Conducted
Group: EMEA Sales > Accessories > Aldo Goldoni > 1011195 AMANITO SMART SHOP
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
12
|
12
|
Pass
|
2
|
Sales Org Currency
|
79
|
79.24
|
Pass
|
3
|
Corporate Currency
|
121
|
120.68
|
Pass
|
Fifth Level Check
Test Conducted
Group: Canada Sales > Mens Apparel > Drew Van Iderstine > 1006966 GAME ON SPORTS > CFL SPR13 MAY 13 13
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
264
|
264
|
Pass
|
2
|
Sales Org Currency
|
5,330
|
5,330.16
|
Pass
|
3
|
Corporate Currency
|
5,235
|
5,234.75
|
Pass
|
Sixth Level Check
Test Conducted
Group: German Sales > Headwear > Jan Henning > 1004350 GALERIA KAUFHOF GMBH > Residual > SEAS BASIC (BLACK BA
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
35
|
35
|
Pass
|
2
|
Sales Org Currency
|
280
|
280.00
|
Pass
|
3
|
Corporate Currency
|
371
|
370.50
|
Pass
|
Dynamic Group 2:
Test Conducted
Dynamic Grouping Parameter(2) and Group Name: Sales Rep > Customer > Season > Collection
Summary Level Check
Test Conducted
Group: Sales Orgs > APAC Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
73,956
|
73,956
|
Pass
|
2
|
Sales Org Currency
|
7,971,473
|
7,971,472.89
|
Pass
|
3
|
Corporate Currency
|
1,027,861
|
1,027,860.96
|
Pass
|
Second Level Check
Test Conducted
Group: Australia Sales > Arthur Kerr
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
18,644
|
18.644
|
Pass
|
2
|
Sales Org Currency
|
353,682
|
353,681.57
|
Pass
|
3
|
Corporate Currency
|
362,418
|
362,417.50
|
Pass
|
Third Level Check
Test Conducted
Group: German Sales > Jan Henning > 1004350 GALERIA KAUFHOF GMBH
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,435
|
1,435
|
Pass
|
2
|
Sales Org Currency
|
17,113
|
17,113.30
|
Pass
|
3
|
Corporate Currency
|
22,644
|
22,644.32
|
Pass
|
Fourth Level Check
Test Conducted
Group: Mexico Sales > Alex Noguera > 1013489 CLUB DE BASE BALL TIGRES SA DE CV > Custom
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
401
|
401
|
Pass
|
2
|
Sales Org Currency
|
62,867
|
62,867.33
|
Pass
|
3
|
Corporate Currency
|
4,929
|
4,928.80
|
Pass
|
Fifth Level Check
Test Conducted
Group: United State Sales > Acker/Tracy > 1004940 KOHLS ACCOUNTS PAYBLE > WomAppFall-Jul 15 13 > 4859W
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity
|
288
|
288
|
Pass
|
2
|
Sales Org Currency
|
4,277
|
4,276.80
|
Pass
|
3
|
Corporate Currency
|
4,277
|
4,276.80
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports